package com.example.dblibrary.database.daos;

/**
 * 歌手表字段
 */
public class SingerIndexConstant {

    public final static int SINGS_DEAULT=-1;//默认值
    public final static int SINGS_ID = 0;//歌曲id
    public final static int SINGS_NUM = 1;//歌曲编号
    public final static int SINGS_NAME = 2;//歌曲名称
    public final static int SINGER = 3;//歌星名
    public final static int SINGS_LANGUAGE = 4;//歌曲语种
    public final static int SINGS_TYPE = 5;//歌曲类型
    public final static int SINGS_MTVORVCD = 6;//歌曲默认音轨
    public final static int SINGS_FIRST_SPELL = 7;//歌曲简写（英文名为全拼音）
    public final static int SINGS_NAME_LENGTH = 8;//歌曲名长度
    public final static int SINGS_TEMP = 9;//歌曲点击量
    public final static int SINGS_FORMAT = 10;//歌曲格式
    public final static int SINGS_EDITION = 11;//歌曲视频版本
    public final static int SINGS_STATUS = 12;//歌曲状态
    public final static int SINGS_PATH = 13;//歌曲存放路径
    public final static int DOWNLOAD_PATH = 14;//歌曲下载路径
    public final static int SINGS_SCORE = 15;//歌曲评分状态
    public final static int SINGS_ADD = 16;//是否为添加歌曲

    public final static int SINGER_ID = 17;//歌手编号
    public final static int SINGER_NAME = 18;//歌手名字
    public final static int SINGER_TYPE = 19;//歌手类型
    public final static int SINGER_AREA = 20;//歌手地域
    public final static int SINGER_FIRST_SPELL = 21;//歌手简写

    public final static String generateCondition(int type, String content) {


        String serachContent="\"'%'"+content+"'%'\"";

        String condition = SingerCondition.getInstance().getColumnByType(type) + " LIKE "+serachContent;

        return condition;
    }
}
